using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;
namespace CXDB{
    /// <summary>
    /// Strongly-typed collection for the VwStaffHrStep1 class.
    /// </summary>
    [Serializable]
    public partial class VwStaffHrStep1Collection : ReadOnlyList<VwStaffHrStep1, VwStaffHrStep1Collection>
    {        
        public VwStaffHrStep1Collection() {}
    }
    /// <summary>
    /// This is  Read-only wrapper class for the vw_Staff_HR_Step1 view.
    /// </summary>
    [Serializable]
    public partial class VwStaffHrStep1 : ReadOnlyRecord<VwStaffHrStep1>, IReadOnlyRecord
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }
	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }
                return BaseSchema;
            }
        }
    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vw_Staff_HR_Step1", TableType.View, DataService.GetInstance("CXDB"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = @"dbo";
                //columns
                
                TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema);
                colvarId.ColumnName = "ID";
                colvarId.DataType = DbType.Int32;
                colvarId.MaxLength = 0;
                colvarId.AutoIncrement = false;
                colvarId.IsNullable = false;
                colvarId.IsPrimaryKey = false;
                colvarId.IsForeignKey = false;
                colvarId.IsReadOnly = false;
                
                schema.Columns.Add(colvarId);
                
                TableSchema.TableColumn colvarUserID = new TableSchema.TableColumn(schema);
                colvarUserID.ColumnName = "userID";
                colvarUserID.DataType = DbType.Int32;
                colvarUserID.MaxLength = 0;
                colvarUserID.AutoIncrement = false;
                colvarUserID.IsNullable = true;
                colvarUserID.IsPrimaryKey = false;
                colvarUserID.IsForeignKey = false;
                colvarUserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarUserID);
                
                TableSchema.TableColumn colvarDeptID = new TableSchema.TableColumn(schema);
                colvarDeptID.ColumnName = "DeptID";
                colvarDeptID.DataType = DbType.Int32;
                colvarDeptID.MaxLength = 0;
                colvarDeptID.AutoIncrement = false;
                colvarDeptID.IsNullable = true;
                colvarDeptID.IsPrimaryKey = false;
                colvarDeptID.IsForeignKey = false;
                colvarDeptID.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptID);
                
                TableSchema.TableColumn colvarTalkTime = new TableSchema.TableColumn(schema);
                colvarTalkTime.ColumnName = "TalkTime";
                colvarTalkTime.DataType = DbType.DateTime;
                colvarTalkTime.MaxLength = 0;
                colvarTalkTime.AutoIncrement = false;
                colvarTalkTime.IsNullable = true;
                colvarTalkTime.IsPrimaryKey = false;
                colvarTalkTime.IsForeignKey = false;
                colvarTalkTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarTalkTime);
                
                TableSchema.TableColumn colvarTalkContent = new TableSchema.TableColumn(schema);
                colvarTalkContent.ColumnName = "TalkContent";
                colvarTalkContent.DataType = DbType.String;
                colvarTalkContent.MaxLength = 1073741823;
                colvarTalkContent.AutoIncrement = false;
                colvarTalkContent.IsNullable = true;
                colvarTalkContent.IsPrimaryKey = false;
                colvarTalkContent.IsForeignKey = false;
                colvarTalkContent.IsReadOnly = false;
                
                schema.Columns.Add(colvarTalkContent);
                
                TableSchema.TableColumn colvarPunishPartyTime = new TableSchema.TableColumn(schema);
                colvarPunishPartyTime.ColumnName = "Punish_party_time";
                colvarPunishPartyTime.DataType = DbType.DateTime;
                colvarPunishPartyTime.MaxLength = 0;
                colvarPunishPartyTime.AutoIncrement = false;
                colvarPunishPartyTime.IsNullable = true;
                colvarPunishPartyTime.IsPrimaryKey = false;
                colvarPunishPartyTime.IsForeignKey = false;
                colvarPunishPartyTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPartyTime);
                
                TableSchema.TableColumn colvarPunishPartyType = new TableSchema.TableColumn(schema);
                colvarPunishPartyType.ColumnName = "Punish_party_type";
                colvarPunishPartyType.DataType = DbType.String;
                colvarPunishPartyType.MaxLength = 100;
                colvarPunishPartyType.AutoIncrement = false;
                colvarPunishPartyType.IsNullable = true;
                colvarPunishPartyType.IsPrimaryKey = false;
                colvarPunishPartyType.IsForeignKey = false;
                colvarPunishPartyType.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPartyType);
                
                TableSchema.TableColumn colvarPunishPartyReason = new TableSchema.TableColumn(schema);
                colvarPunishPartyReason.ColumnName = "Punish_party_reason";
                colvarPunishPartyReason.DataType = DbType.String;
                colvarPunishPartyReason.MaxLength = 1073741823;
                colvarPunishPartyReason.AutoIncrement = false;
                colvarPunishPartyReason.IsNullable = true;
                colvarPunishPartyReason.IsPrimaryKey = false;
                colvarPunishPartyReason.IsForeignKey = false;
                colvarPunishPartyReason.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPartyReason);
                
                TableSchema.TableColumn colvarPunishPenalTime = new TableSchema.TableColumn(schema);
                colvarPunishPenalTime.ColumnName = "Punish_penal_time";
                colvarPunishPenalTime.DataType = DbType.DateTime;
                colvarPunishPenalTime.MaxLength = 0;
                colvarPunishPenalTime.AutoIncrement = false;
                colvarPunishPenalTime.IsNullable = true;
                colvarPunishPenalTime.IsPrimaryKey = false;
                colvarPunishPenalTime.IsForeignKey = false;
                colvarPunishPenalTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPenalTime);
                
                TableSchema.TableColumn colvarPunishPenalType = new TableSchema.TableColumn(schema);
                colvarPunishPenalType.ColumnName = "Punish_penal_type";
                colvarPunishPenalType.DataType = DbType.String;
                colvarPunishPenalType.MaxLength = 100;
                colvarPunishPenalType.AutoIncrement = false;
                colvarPunishPenalType.IsNullable = true;
                colvarPunishPenalType.IsPrimaryKey = false;
                colvarPunishPenalType.IsForeignKey = false;
                colvarPunishPenalType.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPenalType);
                
                TableSchema.TableColumn colvarPunishPenalReason = new TableSchema.TableColumn(schema);
                colvarPunishPenalReason.ColumnName = "Punish_penal_reason";
                colvarPunishPenalReason.DataType = DbType.String;
                colvarPunishPenalReason.MaxLength = 1073741823;
                colvarPunishPenalReason.AutoIncrement = false;
                colvarPunishPenalReason.IsNullable = true;
                colvarPunishPenalReason.IsPrimaryKey = false;
                colvarPunishPenalReason.IsForeignKey = false;
                colvarPunishPenalReason.IsReadOnly = false;
                
                schema.Columns.Add(colvarPunishPenalReason);
                
                TableSchema.TableColumn colvarPartyProblem = new TableSchema.TableColumn(schema);
                colvarPartyProblem.ColumnName = "Party_Problem";
                colvarPartyProblem.DataType = DbType.String;
                colvarPartyProblem.MaxLength = 1073741823;
                colvarPartyProblem.AutoIncrement = false;
                colvarPartyProblem.IsNullable = true;
                colvarPartyProblem.IsPrimaryKey = false;
                colvarPartyProblem.IsForeignKey = false;
                colvarPartyProblem.IsReadOnly = false;
                
                schema.Columns.Add(colvarPartyProblem);
                
                TableSchema.TableColumn colvarOtherProblem = new TableSchema.TableColumn(schema);
                colvarOtherProblem.ColumnName = "Other_Problem";
                colvarOtherProblem.DataType = DbType.String;
                colvarOtherProblem.MaxLength = 1073741823;
                colvarOtherProblem.AutoIncrement = false;
                colvarOtherProblem.IsNullable = true;
                colvarOtherProblem.IsPrimaryKey = false;
                colvarOtherProblem.IsForeignKey = false;
                colvarOtherProblem.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherProblem);
                
                TableSchema.TableColumn colvarEnteringUserID = new TableSchema.TableColumn(schema);
                colvarEnteringUserID.ColumnName = "EnteringUserID";
                colvarEnteringUserID.DataType = DbType.Int32;
                colvarEnteringUserID.MaxLength = 0;
                colvarEnteringUserID.AutoIncrement = false;
                colvarEnteringUserID.IsNullable = true;
                colvarEnteringUserID.IsPrimaryKey = false;
                colvarEnteringUserID.IsForeignKey = false;
                colvarEnteringUserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnteringUserID);
                
                TableSchema.TableColumn colvarADeptMasterID = new TableSchema.TableColumn(schema);
                colvarADeptMasterID.ColumnName = "aDept_MasterID";
                colvarADeptMasterID.DataType = DbType.Int32;
                colvarADeptMasterID.MaxLength = 0;
                colvarADeptMasterID.AutoIncrement = false;
                colvarADeptMasterID.IsNullable = true;
                colvarADeptMasterID.IsPrimaryKey = false;
                colvarADeptMasterID.IsForeignKey = false;
                colvarADeptMasterID.IsReadOnly = false;
                
                schema.Columns.Add(colvarADeptMasterID);
                
                TableSchema.TableColumn colvarADeptMasterRemark = new TableSchema.TableColumn(schema);
                colvarADeptMasterRemark.ColumnName = "aDept_Master_Remark";
                colvarADeptMasterRemark.DataType = DbType.String;
                colvarADeptMasterRemark.MaxLength = 1073741823;
                colvarADeptMasterRemark.AutoIncrement = false;
                colvarADeptMasterRemark.IsNullable = true;
                colvarADeptMasterRemark.IsPrimaryKey = false;
                colvarADeptMasterRemark.IsForeignKey = false;
                colvarADeptMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarADeptMasterRemark);
                
                TableSchema.TableColumn colvarADeptMasterStatus = new TableSchema.TableColumn(schema);
                colvarADeptMasterStatus.ColumnName = "aDept_Master_Status";
                colvarADeptMasterStatus.DataType = DbType.Int32;
                colvarADeptMasterStatus.MaxLength = 0;
                colvarADeptMasterStatus.AutoIncrement = false;
                colvarADeptMasterStatus.IsNullable = true;
                colvarADeptMasterStatus.IsPrimaryKey = false;
                colvarADeptMasterStatus.IsForeignKey = false;
                colvarADeptMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarADeptMasterStatus);
                
                TableSchema.TableColumn colvarADeptMasterEnteringTime = new TableSchema.TableColumn(schema);
                colvarADeptMasterEnteringTime.ColumnName = "aDept_Master_Entering_time";
                colvarADeptMasterEnteringTime.DataType = DbType.DateTime;
                colvarADeptMasterEnteringTime.MaxLength = 0;
                colvarADeptMasterEnteringTime.AutoIncrement = false;
                colvarADeptMasterEnteringTime.IsNullable = true;
                colvarADeptMasterEnteringTime.IsPrimaryKey = false;
                colvarADeptMasterEnteringTime.IsForeignKey = false;
                colvarADeptMasterEnteringTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarADeptMasterEnteringTime);
                
                TableSchema.TableColumn colvarDeptMasterId = new TableSchema.TableColumn(schema);
                colvarDeptMasterId.ColumnName = "Dept_Master_ID";
                colvarDeptMasterId.DataType = DbType.Int32;
                colvarDeptMasterId.MaxLength = 0;
                colvarDeptMasterId.AutoIncrement = false;
                colvarDeptMasterId.IsNullable = true;
                colvarDeptMasterId.IsPrimaryKey = false;
                colvarDeptMasterId.IsForeignKey = false;
                colvarDeptMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterId);
                
                TableSchema.TableColumn colvarDeptMasterRemark = new TableSchema.TableColumn(schema);
                colvarDeptMasterRemark.ColumnName = "Dept_Master_Remark";
                colvarDeptMasterRemark.DataType = DbType.String;
                colvarDeptMasterRemark.MaxLength = 1073741823;
                colvarDeptMasterRemark.AutoIncrement = false;
                colvarDeptMasterRemark.IsNullable = true;
                colvarDeptMasterRemark.IsPrimaryKey = false;
                colvarDeptMasterRemark.IsForeignKey = false;
                colvarDeptMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterRemark);
                
                TableSchema.TableColumn colvarDeptMasterStatus = new TableSchema.TableColumn(schema);
                colvarDeptMasterStatus.ColumnName = "Dept_Master_Status";
                colvarDeptMasterStatus.DataType = DbType.Int32;
                colvarDeptMasterStatus.MaxLength = 0;
                colvarDeptMasterStatus.AutoIncrement = false;
                colvarDeptMasterStatus.IsNullable = true;
                colvarDeptMasterStatus.IsPrimaryKey = false;
                colvarDeptMasterStatus.IsForeignKey = false;
                colvarDeptMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterStatus);
                
                TableSchema.TableColumn colvarDeptMasterEnteringTime = new TableSchema.TableColumn(schema);
                colvarDeptMasterEnteringTime.ColumnName = "Dept_Master_Entering_Time";
                colvarDeptMasterEnteringTime.DataType = DbType.DateTime;
                colvarDeptMasterEnteringTime.MaxLength = 0;
                colvarDeptMasterEnteringTime.AutoIncrement = false;
                colvarDeptMasterEnteringTime.IsNullable = true;
                colvarDeptMasterEnteringTime.IsPrimaryKey = false;
                colvarDeptMasterEnteringTime.IsForeignKey = false;
                colvarDeptMasterEnteringTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterEnteringTime);
                
                TableSchema.TableColumn colvarBossUserID = new TableSchema.TableColumn(schema);
                colvarBossUserID.ColumnName = "Boss_UserID";
                colvarBossUserID.DataType = DbType.Int32;
                colvarBossUserID.MaxLength = 0;
                colvarBossUserID.AutoIncrement = false;
                colvarBossUserID.IsNullable = true;
                colvarBossUserID.IsPrimaryKey = false;
                colvarBossUserID.IsForeignKey = false;
                colvarBossUserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossUserID);
                
                TableSchema.TableColumn colvarBossRemark = new TableSchema.TableColumn(schema);
                colvarBossRemark.ColumnName = "Boss_Remark";
                colvarBossRemark.DataType = DbType.String;
                colvarBossRemark.MaxLength = 1073741823;
                colvarBossRemark.AutoIncrement = false;
                colvarBossRemark.IsNullable = true;
                colvarBossRemark.IsPrimaryKey = false;
                colvarBossRemark.IsForeignKey = false;
                colvarBossRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossRemark);
                
                TableSchema.TableColumn colvarBossStatus = new TableSchema.TableColumn(schema);
                colvarBossStatus.ColumnName = "Boss_Status";
                colvarBossStatus.DataType = DbType.Int32;
                colvarBossStatus.MaxLength = 0;
                colvarBossStatus.AutoIncrement = false;
                colvarBossStatus.IsNullable = true;
                colvarBossStatus.IsPrimaryKey = false;
                colvarBossStatus.IsForeignKey = false;
                colvarBossStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossStatus);
                
                TableSchema.TableColumn colvarBossTime = new TableSchema.TableColumn(schema);
                colvarBossTime.ColumnName = "Boss_Time";
                colvarBossTime.DataType = DbType.DateTime;
                colvarBossTime.MaxLength = 0;
                colvarBossTime.AutoIncrement = false;
                colvarBossTime.IsNullable = true;
                colvarBossTime.IsPrimaryKey = false;
                colvarBossTime.IsForeignKey = false;
                colvarBossTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossTime);
                
                TableSchema.TableColumn colvarInTime = new TableSchema.TableColumn(schema);
                colvarInTime.ColumnName = "inTime";
                colvarInTime.DataType = DbType.DateTime;
                colvarInTime.MaxLength = 0;
                colvarInTime.AutoIncrement = false;
                colvarInTime.IsNullable = true;
                colvarInTime.IsPrimaryKey = false;
                colvarInTime.IsForeignKey = false;
                colvarInTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarInTime);
                
                TableSchema.TableColumn colvarStatus = new TableSchema.TableColumn(schema);
                colvarStatus.ColumnName = "Status";
                colvarStatus.DataType = DbType.Int32;
                colvarStatus.MaxLength = 0;
                colvarStatus.AutoIncrement = false;
                colvarStatus.IsNullable = true;
                colvarStatus.IsPrimaryKey = false;
                colvarStatus.IsForeignKey = false;
                colvarStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarStatus);
                
                TableSchema.TableColumn colvarEdUsername = new TableSchema.TableColumn(schema);
                colvarEdUsername.ColumnName = "ED_Username";
                colvarEdUsername.DataType = DbType.String;
                colvarEdUsername.MaxLength = 50;
                colvarEdUsername.AutoIncrement = false;
                colvarEdUsername.IsNullable = true;
                colvarEdUsername.IsPrimaryKey = false;
                colvarEdUsername.IsForeignKey = false;
                colvarEdUsername.IsReadOnly = false;
                
                schema.Columns.Add(colvarEdUsername);
                
                TableSchema.TableColumn colvarEdDeptName = new TableSchema.TableColumn(schema);
                colvarEdDeptName.ColumnName = "ED_DeptName";
                colvarEdDeptName.DataType = DbType.String;
                colvarEdDeptName.MaxLength = 50;
                colvarEdDeptName.AutoIncrement = false;
                colvarEdDeptName.IsNullable = true;
                colvarEdDeptName.IsPrimaryKey = false;
                colvarEdDeptName.IsForeignKey = false;
                colvarEdDeptName.IsReadOnly = false;
                
                schema.Columns.Add(colvarEdDeptName);
                
                TableSchema.TableColumn colvarEnterUsername = new TableSchema.TableColumn(schema);
                colvarEnterUsername.ColumnName = "Enter_username";
                colvarEnterUsername.DataType = DbType.String;
                colvarEnterUsername.MaxLength = 50;
                colvarEnterUsername.AutoIncrement = false;
                colvarEnterUsername.IsNullable = true;
                colvarEnterUsername.IsPrimaryKey = false;
                colvarEnterUsername.IsForeignKey = false;
                colvarEnterUsername.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnterUsername);
                
                TableSchema.TableColumn colvarGuid = new TableSchema.TableColumn(schema);
                colvarGuid.ColumnName = "Guid";
                colvarGuid.DataType = DbType.Guid;
                colvarGuid.MaxLength = 0;
                colvarGuid.AutoIncrement = false;
                colvarGuid.IsNullable = true;
                colvarGuid.IsPrimaryKey = false;
                colvarGuid.IsForeignKey = false;
                colvarGuid.IsReadOnly = false;
                
                schema.Columns.Add(colvarGuid);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["CXDB"].AddSchema("vw_Staff_HR_Step1",schema);
            }
        }
        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }
	    #endregion
	    
	    #region .ctors
	    public VwStaffHrStep1()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }
        public VwStaffHrStep1(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}
			MarkNew();
	    }
	    
	    public VwStaffHrStep1(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }
    	 
	    public VwStaffHrStep1(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }
        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("Id")]
        [Bindable(true)]
        public int Id 
	    {
		    get
		    {
			    return GetColumnValue<int>("ID");
		    }
            set 
		    {
			    SetColumnValue("ID", value);
            }
        }
	      
        [XmlAttribute("UserID")]
        [Bindable(true)]
        public int? UserID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("userID");
		    }
            set 
		    {
			    SetColumnValue("userID", value);
            }
        }
	      
        [XmlAttribute("DeptID")]
        [Bindable(true)]
        public int? DeptID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("DeptID");
		    }
            set 
		    {
			    SetColumnValue("DeptID", value);
            }
        }
	      
        [XmlAttribute("TalkTime")]
        [Bindable(true)]
        public DateTime? TalkTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("TalkTime");
		    }
            set 
		    {
			    SetColumnValue("TalkTime", value);
            }
        }
	      
        [XmlAttribute("TalkContent")]
        [Bindable(true)]
        public string TalkContent 
	    {
		    get
		    {
			    return GetColumnValue<string>("TalkContent");
		    }
            set 
		    {
			    SetColumnValue("TalkContent", value);
            }
        }
	      
        [XmlAttribute("PunishPartyTime")]
        [Bindable(true)]
        public DateTime? PunishPartyTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Punish_party_time");
		    }
            set 
		    {
			    SetColumnValue("Punish_party_time", value);
            }
        }
	      
        [XmlAttribute("PunishPartyType")]
        [Bindable(true)]
        public string PunishPartyType 
	    {
		    get
		    {
			    return GetColumnValue<string>("Punish_party_type");
		    }
            set 
		    {
			    SetColumnValue("Punish_party_type", value);
            }
        }
	      
        [XmlAttribute("PunishPartyReason")]
        [Bindable(true)]
        public string PunishPartyReason 
	    {
		    get
		    {
			    return GetColumnValue<string>("Punish_party_reason");
		    }
            set 
		    {
			    SetColumnValue("Punish_party_reason", value);
            }
        }
	      
        [XmlAttribute("PunishPenalTime")]
        [Bindable(true)]
        public DateTime? PunishPenalTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Punish_penal_time");
		    }
            set 
		    {
			    SetColumnValue("Punish_penal_time", value);
            }
        }
	      
        [XmlAttribute("PunishPenalType")]
        [Bindable(true)]
        public string PunishPenalType 
	    {
		    get
		    {
			    return GetColumnValue<string>("Punish_penal_type");
		    }
            set 
		    {
			    SetColumnValue("Punish_penal_type", value);
            }
        }
	      
        [XmlAttribute("PunishPenalReason")]
        [Bindable(true)]
        public string PunishPenalReason 
	    {
		    get
		    {
			    return GetColumnValue<string>("Punish_penal_reason");
		    }
            set 
		    {
			    SetColumnValue("Punish_penal_reason", value);
            }
        }
	      
        [XmlAttribute("PartyProblem")]
        [Bindable(true)]
        public string PartyProblem 
	    {
		    get
		    {
			    return GetColumnValue<string>("Party_Problem");
		    }
            set 
		    {
			    SetColumnValue("Party_Problem", value);
            }
        }
	      
        [XmlAttribute("OtherProblem")]
        [Bindable(true)]
        public string OtherProblem 
	    {
		    get
		    {
			    return GetColumnValue<string>("Other_Problem");
		    }
            set 
		    {
			    SetColumnValue("Other_Problem", value);
            }
        }
	      
        [XmlAttribute("EnteringUserID")]
        [Bindable(true)]
        public int? EnteringUserID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("EnteringUserID");
		    }
            set 
		    {
			    SetColumnValue("EnteringUserID", value);
            }
        }
	      
        [XmlAttribute("ADeptMasterID")]
        [Bindable(true)]
        public int? ADeptMasterID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("aDept_MasterID");
		    }
            set 
		    {
			    SetColumnValue("aDept_MasterID", value);
            }
        }
	      
        [XmlAttribute("ADeptMasterRemark")]
        [Bindable(true)]
        public string ADeptMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("aDept_Master_Remark");
		    }
            set 
		    {
			    SetColumnValue("aDept_Master_Remark", value);
            }
        }
	      
        [XmlAttribute("ADeptMasterStatus")]
        [Bindable(true)]
        public int? ADeptMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("aDept_Master_Status");
		    }
            set 
		    {
			    SetColumnValue("aDept_Master_Status", value);
            }
        }
	      
        [XmlAttribute("ADeptMasterEnteringTime")]
        [Bindable(true)]
        public DateTime? ADeptMasterEnteringTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("aDept_Master_Entering_time");
		    }
            set 
		    {
			    SetColumnValue("aDept_Master_Entering_time", value);
            }
        }
	      
        [XmlAttribute("DeptMasterId")]
        [Bindable(true)]
        public int? DeptMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_Master_ID");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_ID", value);
            }
        }
	      
        [XmlAttribute("DeptMasterRemark")]
        [Bindable(true)]
        public string DeptMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Dept_Master_Remark");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_Remark", value);
            }
        }
	      
        [XmlAttribute("DeptMasterStatus")]
        [Bindable(true)]
        public int? DeptMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_Master_Status");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_Status", value);
            }
        }
	      
        [XmlAttribute("DeptMasterEnteringTime")]
        [Bindable(true)]
        public DateTime? DeptMasterEnteringTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Dept_Master_Entering_Time");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_Entering_Time", value);
            }
        }
	      
        [XmlAttribute("BossUserID")]
        [Bindable(true)]
        public int? BossUserID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Boss_UserID");
		    }
            set 
		    {
			    SetColumnValue("Boss_UserID", value);
            }
        }
	      
        [XmlAttribute("BossRemark")]
        [Bindable(true)]
        public string BossRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Boss_Remark");
		    }
            set 
		    {
			    SetColumnValue("Boss_Remark", value);
            }
        }
	      
        [XmlAttribute("BossStatus")]
        [Bindable(true)]
        public int? BossStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Boss_Status");
		    }
            set 
		    {
			    SetColumnValue("Boss_Status", value);
            }
        }
	      
        [XmlAttribute("BossTime")]
        [Bindable(true)]
        public DateTime? BossTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Boss_Time");
		    }
            set 
		    {
			    SetColumnValue("Boss_Time", value);
            }
        }
	      
        [XmlAttribute("InTime")]
        [Bindable(true)]
        public DateTime? InTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("inTime");
		    }
            set 
		    {
			    SetColumnValue("inTime", value);
            }
        }
	      
        [XmlAttribute("Status")]
        [Bindable(true)]
        public int? Status 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Status");
		    }
            set 
		    {
			    SetColumnValue("Status", value);
            }
        }
	      
        [XmlAttribute("EdUsername")]
        [Bindable(true)]
        public string EdUsername 
	    {
		    get
		    {
			    return GetColumnValue<string>("ED_Username");
		    }
            set 
		    {
			    SetColumnValue("ED_Username", value);
            }
        }
	      
        [XmlAttribute("EdDeptName")]
        [Bindable(true)]
        public string EdDeptName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ED_DeptName");
		    }
            set 
		    {
			    SetColumnValue("ED_DeptName", value);
            }
        }
	      
        [XmlAttribute("EnterUsername")]
        [Bindable(true)]
        public string EnterUsername 
	    {
		    get
		    {
			    return GetColumnValue<string>("Enter_username");
		    }
            set 
		    {
			    SetColumnValue("Enter_username", value);
            }
        }
	      
        [XmlAttribute("Guid")]
        [Bindable(true)]
        public Guid? Guid 
	    {
		    get
		    {
			    return GetColumnValue<Guid?>("Guid");
		    }
            set 
		    {
			    SetColumnValue("Guid", value);
            }
        }
	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string Id = @"ID";
            
            public static string UserID = @"userID";
            
            public static string DeptID = @"DeptID";
            
            public static string TalkTime = @"TalkTime";
            
            public static string TalkContent = @"TalkContent";
            
            public static string PunishPartyTime = @"Punish_party_time";
            
            public static string PunishPartyType = @"Punish_party_type";
            
            public static string PunishPartyReason = @"Punish_party_reason";
            
            public static string PunishPenalTime = @"Punish_penal_time";
            
            public static string PunishPenalType = @"Punish_penal_type";
            
            public static string PunishPenalReason = @"Punish_penal_reason";
            
            public static string PartyProblem = @"Party_Problem";
            
            public static string OtherProblem = @"Other_Problem";
            
            public static string EnteringUserID = @"EnteringUserID";
            
            public static string ADeptMasterID = @"aDept_MasterID";
            
            public static string ADeptMasterRemark = @"aDept_Master_Remark";
            
            public static string ADeptMasterStatus = @"aDept_Master_Status";
            
            public static string ADeptMasterEnteringTime = @"aDept_Master_Entering_time";
            
            public static string DeptMasterId = @"Dept_Master_ID";
            
            public static string DeptMasterRemark = @"Dept_Master_Remark";
            
            public static string DeptMasterStatus = @"Dept_Master_Status";
            
            public static string DeptMasterEnteringTime = @"Dept_Master_Entering_Time";
            
            public static string BossUserID = @"Boss_UserID";
            
            public static string BossRemark = @"Boss_Remark";
            
            public static string BossStatus = @"Boss_Status";
            
            public static string BossTime = @"Boss_Time";
            
            public static string InTime = @"inTime";
            
            public static string Status = @"Status";
            
            public static string EdUsername = @"ED_Username";
            
            public static string EdDeptName = @"ED_DeptName";
            
            public static string EnterUsername = @"Enter_username";
            
            public static string Guid = @"Guid";
            
	    }
	    #endregion
	    
	    
	    #region IAbstractRecord Members
        public new CT GetColumnValue<CT>(string columnName) {
            return base.GetColumnValue<CT>(columnName);
        }
        public object GetColumnValue(string columnName) {
            return base.GetColumnValue<object>(columnName);
        }
        #endregion
	    
    }
}
